/*
 * Copyright (c) 2017-2022 TIBCO Software Inc. All rights reserved.
 *
 * Licensed under the Apache License, Version 2.0 (the "License"); you
 * may not use this file except in compliance with the License. You
 * may obtain a copy of the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or
 * implied. See the License for the specific language governing
 * permissions and limitations under the License. See accompanying
 * LICENSE file.
 */
package io.snappydata.hydra.udfs

import com.typesafe.config.Config
import org.apache.spark.sql._

class Validate_SNAP2658 extends SnappySQLJob{
  override def isValidJob(sc: SnappySession, config: Config): SnappyJobValidation = SnappyJobValid()

  override def runSnappyJob(snappySession: SnappySession, jobConfig: Config): Any = {
    // scalastyle:off println
    val snc : SnappyContext = snappySession.sqlContext

    snc.sql("CREATE FUNCTION MyUDF AS io.snappydata.hydra.TestUDF1" +
            " RETURNS INTEGER USING JAR '/export/shared/QA_DATA/SNAP-2658/UDF1/TestUDF.jar'")
    println(snc.sql("SELECT MyUDF(100)").show())
    snc.sql("DROP FUNCTION MyUDF")

        snc.sql("CREATE FUNCTION MyUDF AS io.snappydata.hydra.TestUDF1" +
          " RETURNS INTEGER USING JAR '/export/shared/QA_DATA/SNAP-2658/UDF2/TestUDF.jar'")
    println(snc.sql("SELECT MyUDF(1000)").show())
    snc.sql("DROP FUNCTION MyUDF")
  }
}
